Create Procedure sp_asi_FetchImage  @fieldname varchar(255),      @where varchar(255),      @pos int,      @size int AS declare @ptrval varchar(16),  @sqlstring varchar(255),  @tablename varchar(255) SELECT @tablename = SUBSTRING(@fieldname,1,CHARINDEX('.',@fieldname)-1) SELECT @sqlstring =  'declare @ptrval binary(16)' +     ' SELECT @ptrval=TEXTPTR(' + @fieldname + ')' +     ' FROM ' + @tablename + ' ' + @where +    ' if @ptrval <> NULL READTEXT ' + @fieldname + ' @ptrval ' +    CONVERT(varchar,@pos) + ' ' + CONVERT(varchar,@size) +    ' else SELECT NULL' EXECUTE (@sqlstring)

GO
GRANT EXECUTE ON  [dbo].[sp_asi_FetchImage] TO [IMIS]
GO